SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59101: Database backup fails with the SAS® Deployment Backup and Recovery Tool and returns "COMMAND_TOOL_ERROR_PGBACKUP"

DetailsAboutRate It

The Deployment Backup and Recovery Tool might report a failure when performing a backup of the EVManager database when your deployment is SAS 9.4TS1M3.  When the database backup fails, the Deployment Backup and Recovery Tool reports an exception like the one shown here:

Got Exception as follows:
Backup Errors
         Error Entry:
                 Status Code: 311
                 Name: COMMAND_TOOL_ERROR_PGBACKUP
                 Category: DATABASE
                 Classification: ERROR
                 Date and Time Of Error: 2016-09-01T01_09_43
                 Log Name: backupserver.log
                 Log File Location: /usr/local/SAS/config/Lev1/Backup
                 Originating Tier: Host: yourhost.yourdomain.com
                 Configuration Directory: /usr/local/SAS/config/Lev1
                 Message: An error encountered in the pg_backup utility.

When you look at the backupserver.log, you see LOCK TABLE and IN ACCESS SHARE MODE.

Here is an example:

INFO com.sas.svcs.backup.server.handler.PostgresBackupHandler - pg_dump: The command was: LOCK TABLE public.hq_metric_data_3d_0s IN ACCESS SHARE MODE

This issue has been fixed in SAS® 9.4TS1M4 software. If your software is SAS® 9.4TS1M3, use the workaround provided below.

Workaround

To work around the problem, you need to replace your hq-server-5.8.0.jar with an updated version of the file. Before replacing the file, you must first stop the SAS® Environment Manager. 

  1. Stop the SAS Environment Manager.

      2. Locate the hq-server-5.8.0.jar file.   Here is an example:

  SAS-configuration-directory\LevN\Web\SASEnvironmentManager\server-5.8.0-EE\hq-engine\hq server\webapps\ROOT\WEB-INF\lib

      3. Make a backup of your hq-server-5.8.0.jar file by renaming the file to hq-server-5.8.0.jar.old

      4. Download and save a new hq-server-5.8.0.jar file from here: hq-server-5.8.0.jar.txt

          Important: Do not open the file.

      5. Rename hq-server-5.8.0.jar.txt to hq-server-5.8.0.jar and then copy the file to this location:

 SAS-configuration-directory\LevN\Web\SASEnvironmentManager\server-5.8.0-EE\hq-engine\hq-engine\hq-server\webapps\ROOT\WEB-INF\lib

       6.  Restart the SAS Environment Manager Server.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Environment ManagerMicrosoft® Windows® for x642.52.59.4 TS1M39.4 TS1M4
64-bit Enabled AIX2.52.59.4 TS1M39.4 TS1M4
64-bit Enabled Solaris2.52.59.4 TS1M39.4 TS1M4
HP-UX IPF2.52.59.4 TS1M39.4 TS1M4
Linux for x642.52.59.4 TS1M39.4 TS1M4
Solaris for x642.52.59.4 TS1M39.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.